package com.ourteam.product.requirement.dao;

import net.dao.BaseQueryBean;
import net.dao.BaseWhereCriterion;
import net.dao.IDataAccessInterface;

import org.apache.commons.lang.StringUtils;

import java.util.Arrays;
import java.util.List;
import java.util.Map;


/**
 * Template Name : DAO查询对象
 * Template Version : 1
 * Template Last Modfiy Date : Sat Aug 19 10:06:32 CST 2017
 * Auto Generate Date : 2018-05-03 16:45:28
  * Warning ! This file will be overwrite when regenerate !
  *
 */
public class ProductRequirementChangeLogDAOQueryBean extends BaseQueryBean {
    public ProductRequirementChangeLogDAOQueryBean() {
        super();
    }

    public ProductRequirementChangeLogDAOQueryBean(BaseQueryBean aQueryBean) {
        super(aQueryBean);
    }

    public ProductRequirementChangeLogDAOQueryBean(BaseQueryBean aQueryBean,
        Map tableReplaceMap) {
        super(aQueryBean, tableReplaceMap);
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();

        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }

        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        return new Criteria(this);
    }

    public void addIdSelectProperty() {
        addIdSelectProperty("id");
    }

    public void addIdSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(IProductRequirementChangeLogDAO.Id, aAlias);
        } else {
            addSelectProperty(IProductRequirementChangeLogDAO.Id, "id");
        }
    }

    public void addProductRequirementIdSelectProperty() {
        addProductRequirementIdSelectProperty("productRequirementId");
    }

    public void addProductRequirementIdSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(IProductRequirementChangeLogDAO.ProductRequirementId,
                aAlias);
        } else {
            addSelectProperty(IProductRequirementChangeLogDAO.ProductRequirementId,
                "productRequirementId");
        }
    }

    public void addBeforeChangeContentSelectProperty() {
        addBeforeChangeContentSelectProperty("beforeChangeContent");
    }

    public void addBeforeChangeContentSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(IProductRequirementChangeLogDAO.BeforeChangeContent,
                aAlias);
        } else {
            addSelectProperty(IProductRequirementChangeLogDAO.BeforeChangeContent,
                "beforeChangeContent");
        }
    }

    public void addAfterChangeContentSelectProperty() {
        addAfterChangeContentSelectProperty("afterChangeContent");
    }

    public void addAfterChangeContentSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(IProductRequirementChangeLogDAO.AfterChangeContent,
                aAlias);
        } else {
            addSelectProperty(IProductRequirementChangeLogDAO.AfterChangeContent,
                "afterChangeContent");
        }
    }

    public void addEditorIdSelectProperty() {
        addEditorIdSelectProperty("editorId");
    }

    public void addEditorIdSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(IProductRequirementChangeLogDAO.EditorId, aAlias);
        } else {
            addSelectProperty(IProductRequirementChangeLogDAO.EditorId,
                "editorId");
        }
    }

    public void addEditDateSelectProperty() {
        addEditDateSelectProperty("editDate");
    }

    public void addEditDateSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(IProductRequirementChangeLogDAO.EditDate, aAlias);
        } else {
            addSelectProperty(IProductRequirementChangeLogDAO.EditDate,
                "editDate");
        }
    }

    public void addChangeReasonSelectProperty() {
        addChangeReasonSelectProperty("changeReason");
    }

    public void addChangeReasonSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(IProductRequirementChangeLogDAO.ChangeReason,
                aAlias);
        } else {
            addSelectProperty(IProductRequirementChangeLogDAO.ChangeReason,
                "changeReason");
        }
    }

    public void addApproverIdSelectProperty() {
        addApproverIdSelectProperty("approverId");
    }

    public void addApproverIdSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(IProductRequirementChangeLogDAO.ApproverId, aAlias);
        } else {
            addSelectProperty(IProductRequirementChangeLogDAO.ApproverId,
                "approverId");
        }
    }

    public void addStatusSelectProperty() {
        addStatusSelectProperty("status");
    }

    public void addStatusSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(IProductRequirementChangeLogDAO.Status, aAlias);
        } else {
            addSelectProperty(IProductRequirementChangeLogDAO.Status, "status");
        }
    }

    public void addRemarksSelectProperty() {
        addRemarksSelectProperty("remarks");
    }

    public void addRemarksSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(IProductRequirementChangeLogDAO.Remarks, aAlias);
        } else {
            addSelectProperty(IProductRequirementChangeLogDAO.Remarks, "remarks");
        }
    }

    public void addAllSelectProperties() {
        addIdSelectProperty();

        addProductRequirementIdSelectProperty();

        addBeforeChangeContentSelectProperty();

        addAfterChangeContentSelectProperty();

        addEditorIdSelectProperty();

        addEditDateSelectProperty();

        addChangeReasonSelectProperty();

        addApproverIdSelectProperty();

        addStatusSelectProperty();

        addRemarksSelectProperty();
    }

    public static class Criteria extends BaseWhereCriterion<ProductRequirementChangeLogDAOQueryBean> {
        protected Criteria(
            ProductRequirementChangeLogDAOQueryBean aParentObject) {
            super(aParentObject);
        }

        public Criteria andIdIsNull() {
            addCriterion(IProductRequirementChangeLogDAO.Id + " is null");

            return this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion(IProductRequirementChangeLogDAO.Id + " is not null");

            return this;
        }

        public Criteria andIdIsNotEmpty() {
            addCriterion(IProductRequirementChangeLogDAO.Id +
                " is not null AND " + IProductRequirementChangeLogDAO.Id +
                " <> ''");

            return this;
        }

        public Criteria andIdIsEmpty() {
            addCriterion("(" + IProductRequirementChangeLogDAO.Id +
                " is null OR " + IProductRequirementChangeLogDAO.Id + " = '')");

            return this;
        }

        public Criteria andIdEqualTo(long value) {
            return andIdEqualTo(Long.valueOf(value));
        }

        public Criteria andIdEqualTo(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.Id + " = ", value, "id");

            return this;
        }

        public Criteria andIdEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.Id);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.Id + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIdNotEqualTo(long value) {
            return andIdNotEqualTo(Long.valueOf(value));
        }

        public Criteria andIdNotEqualTo(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.Id + " <>", value, "id");

            return this;
        }

        public Criteria andIdNotEqualToOrIsNull(long value) {
            return andIdNotEqualToOrIsNull(Long.valueOf(value));
        }

        public Criteria andIdNotEqualToOrIsNull(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.Id + " is null OR " +
                IProductRequirementChangeLogDAO.Id + " <>", value, "id");

            return this;
        }

        public Criteria andIdNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.Id);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.Id + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIdGreaterThan(long value) {
            return andIdGreaterThan(Long.valueOf(value));
        }

        public Criteria andIdGreaterThan(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.Id + " >", value, "id");

            return this;
        }

        public Criteria andIdGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.Id);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.Id + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIdGreaterThanOrEqualTo(long value) {
            return andIdGreaterThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andIdGreaterThanOrEqualTo(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.Id + " >=", value, "id");

            return this;
        }

        public Criteria andIdGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.Id);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.Id + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIdLessThan(long value) {
            return andIdLessThan(Long.valueOf(value));
        }

        public Criteria andIdLessThan(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.Id + " <", value, "id");

            return this;
        }

        public Criteria andIdLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.Id);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.Id + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIdLessThanOrEqualTo(long value) {
            return andIdLessThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andIdLessThanOrEqualTo(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.Id + " <=", value, "id");

            return this;
        }

        public Criteria andIdLessThanOrEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.Id);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.Id + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIdIn(long[] values) {
            if (values.length == 1) {
                return andIdEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.Id + " in",
                    values, "id");

                return this;
            }
        }

        public Criteria andIdNotIn(long[] values) {
            if (values.length == 1) {
                return andIdNotEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.Id + " not in",
                    values, "id");

                return this;
            }
        }

        public Criteria andIdIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andIdEqualTo(values.get(0));
            } else {
                addCriterion(IProductRequirementChangeLogDAO.Id + " in",
                    values, "id");

                return this;
            }
        }

        public Criteria andIdNotIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andIdNotEqualTo(values.get(0));
            } else {
                addCriterion(IProductRequirementChangeLogDAO.Id + " not in",
                    values, "id");

                return this;
            }
        }

        public Criteria andIdIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andIdEqualTo(values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.Id + " in",
                    Arrays.asList(values), "id");

                return this;
            }
        }

        public Criteria andIdNotIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andIdNotEqualTo(values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.Id + " not in",
                    Arrays.asList(values), "id");

                return this;
            }
        }

        public Criteria andIdIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.Id + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIdNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.Id + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIdBetween(long value1, long value2) {
            addCriterion(IProductRequirementChangeLogDAO.Id + " between",
                value1, value2, "id");

            return this;
        }

        public Criteria andIdBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(IProductRequirementChangeLogDAO.Id + " between",
                value1, value2, "id");

            return this;
        }

        public Criteria andIdNotBetween(long value1, long value2) {
            addCriterion(IProductRequirementChangeLogDAO.Id + " not between",
                value1, value2, "id");

            return this;
        }

        public Criteria andIdNotBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(IProductRequirementChangeLogDAO.Id + " not between",
                value1, value2, "id");

            return this;
        }

        public Criteria andProductRequirementIdIsNull() {
            addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                " is null");

            return this;
        }

        public Criteria andProductRequirementIdIsNotNull() {
            addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                " is not null");

            return this;
        }

        public Criteria andProductRequirementIdIsNotEmpty() {
            addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                " is not null AND " +
                IProductRequirementChangeLogDAO.ProductRequirementId +
                " <> ''");

            return this;
        }

        public Criteria andProductRequirementIdIsEmpty() {
            addCriterion("(" +
                IProductRequirementChangeLogDAO.ProductRequirementId +
                " is null OR " +
                IProductRequirementChangeLogDAO.ProductRequirementId +
                " = '')");

            return this;
        }

        public Criteria andProductRequirementIdEqualTo(long value) {
            return andProductRequirementIdEqualTo(Long.valueOf(value));
        }

        public Criteria andProductRequirementIdEqualTo(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                " = ", value, "productRequirementId");

            return this;
        }

        public Criteria andProductRequirementIdEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.ProductRequirementId);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andProductRequirementIdEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andProductRequirementIdNotEqualTo(long value) {
            return andProductRequirementIdNotEqualTo(Long.valueOf(value));
        }

        public Criteria andProductRequirementIdNotEqualTo(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                " <>", value, "productRequirementId");

            return this;
        }

        public Criteria andProductRequirementIdNotEqualToOrIsNull(long value) {
            return andProductRequirementIdNotEqualToOrIsNull(Long.valueOf(value));
        }

        public Criteria andProductRequirementIdNotEqualToOrIsNull(
            java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                " is null OR " +
                IProductRequirementChangeLogDAO.ProductRequirementId + " <>",
                value, "productRequirementId");

            return this;
        }

        public Criteria andProductRequirementIdNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.ProductRequirementId);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andProductRequirementIdNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andProductRequirementIdGreaterThan(long value) {
            return andProductRequirementIdGreaterThan(Long.valueOf(value));
        }

        public Criteria andProductRequirementIdGreaterThan(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                " >", value, "productRequirementId");

            return this;
        }

        public Criteria andProductRequirementIdGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.ProductRequirementId);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andProductRequirementIdGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andProductRequirementIdGreaterThanOrEqualTo(long value) {
            return andProductRequirementIdGreaterThanOrEqualTo(Long.valueOf(
                    value));
        }

        public Criteria andProductRequirementIdGreaterThanOrEqualTo(
            java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                " >=", value, "productRequirementId");

            return this;
        }

        public Criteria andProductRequirementIdGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.ProductRequirementId);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andProductRequirementIdGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andProductRequirementIdLessThan(long value) {
            return andProductRequirementIdLessThan(Long.valueOf(value));
        }

        public Criteria andProductRequirementIdLessThan(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                " <", value, "productRequirementId");

            return this;
        }

        public Criteria andProductRequirementIdLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.ProductRequirementId);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andProductRequirementIdLessThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andProductRequirementIdLessThanOrEqualTo(long value) {
            return andProductRequirementIdLessThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andProductRequirementIdLessThanOrEqualTo(
            java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                " <=", value, "productRequirementId");

            return this;
        }

        public Criteria andProductRequirementIdLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.ProductRequirementId);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andProductRequirementIdLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andProductRequirementIdIn(long[] values) {
            if (values.length == 1) {
                return andProductRequirementIdEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                    " in", values, "productRequirementId");

                return this;
            }
        }

        public Criteria andProductRequirementIdNotIn(long[] values) {
            if (values.length == 1) {
                return andProductRequirementIdNotEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                    " not in", values, "productRequirementId");

                return this;
            }
        }

        public Criteria andProductRequirementIdIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andProductRequirementIdEqualTo(values.get(0));
            } else {
                addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                    " in", values, "productRequirementId");

                return this;
            }
        }

        public Criteria andProductRequirementIdNotIn(
            List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andProductRequirementIdNotEqualTo(values.get(0));
            } else {
                addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                    " not in", values, "productRequirementId");

                return this;
            }
        }

        public Criteria andProductRequirementIdIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andProductRequirementIdEqualTo(values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                    " in", Arrays.asList(values), "productRequirementId");

                return this;
            }
        }

        public Criteria andProductRequirementIdNotIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andProductRequirementIdNotEqualTo(values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                    " not in", Arrays.asList(values), "productRequirementId");

                return this;
            }
        }

        public Criteria andProductRequirementIdIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andProductRequirementIdNotIn(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andProductRequirementIdBetween(long value1, long value2) {
            addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                " between", value1, value2, "productRequirementId");

            return this;
        }

        public Criteria andProductRequirementIdBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                " between", value1, value2, "productRequirementId");

            return this;
        }

        public Criteria andProductRequirementIdNotBetween(long value1,
            long value2) {
            addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                " not between", value1, value2, "productRequirementId");

            return this;
        }

        public Criteria andProductRequirementIdNotBetween(
            java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IProductRequirementChangeLogDAO.ProductRequirementId +
                " not between", value1, value2, "productRequirementId");

            return this;
        }

        public Criteria andBeforeChangeContentIsNull() {
            addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                " is null");

            return this;
        }

        public Criteria andBeforeChangeContentIsNotNull() {
            addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                " is not null");

            return this;
        }

        public Criteria andBeforeChangeContentIsNotEmpty() {
            addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                " is not null AND " +
                IProductRequirementChangeLogDAO.BeforeChangeContent + " <> ''");

            return this;
        }

        public Criteria andBeforeChangeContentIsEmpty() {
            addCriterion("(" +
                IProductRequirementChangeLogDAO.BeforeChangeContent +
                " is null OR " +
                IProductRequirementChangeLogDAO.BeforeChangeContent + " = '')");

            return this;
        }

        public Criteria andBeforeChangeContentEqualTo(String value) {
            addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                " = ", value, "beforeChangeContent");

            return this;
        }

        public Criteria andBeforeChangeContentEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.BeforeChangeContent);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andBeforeChangeContentEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andBeforeChangeContentNotEqualTo(String value) {
            addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                " <>", value, "beforeChangeContent");

            return this;
        }

        public Criteria andBeforeChangeContentNotEqualToOrIsNull(String value) {
            addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                " is null OR " +
                IProductRequirementChangeLogDAO.BeforeChangeContent + " <>",
                value, "beforeChangeContent");

            return this;
        }

        public Criteria andBeforeChangeContentNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.BeforeChangeContent);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andBeforeChangeContentNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andBeforeChangeContentGreaterThan(String value) {
            addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                " >", value, "beforeChangeContent");

            return this;
        }

        public Criteria andBeforeChangeContentGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.BeforeChangeContent);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andBeforeChangeContentGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andBeforeChangeContentGreaterThanOrEqualTo(String value) {
            addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                " >=", value, "beforeChangeContent");

            return this;
        }

        public Criteria andBeforeChangeContentGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.BeforeChangeContent);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andBeforeChangeContentGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andBeforeChangeContentLessThan(String value) {
            addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                " <", value, "beforeChangeContent");

            return this;
        }

        public Criteria andBeforeChangeContentLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.BeforeChangeContent);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andBeforeChangeContentLessThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andBeforeChangeContentLessThanOrEqualTo(String value) {
            addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                " <=", value, "beforeChangeContent");

            return this;
        }

        public Criteria andBeforeChangeContentLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.BeforeChangeContent);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andBeforeChangeContentLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andBeforeChangeContentLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                " like", buffer.toString(), "beforeChangeContent");

            return this;
        }

        public Criteria andBeforeChangeContentNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                " not like", buffer.toString(), "beforeChangeContent");

            return this;
        }

        public Criteria andBeforeChangeContentIn(List<String> values) {
            if (values.size() == 1) {
                return andBeforeChangeContentEqualTo(values.get(0));
            } else {
                addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                    " in", values, "beforeChangeContent");

                return this;
            }
        }

        public Criteria andBeforeChangeContentNotIn(List<String> values) {
            if (values.size() == 1) {
                return andBeforeChangeContentNotEqualTo(values.get(0));
            } else {
                addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                    " not in", values, "beforeChangeContent");

                return this;
            }
        }

        public Criteria andBeforeChangeContentIn(String[] values) {
            if (values.length == 1) {
                return andBeforeChangeContentEqualTo(values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                    " in", Arrays.asList(values), "beforeChangeContent");

                return this;
            }
        }

        public Criteria andBeforeChangeContentNotIn(String[] values) {
            if (values.length == 1) {
                return andBeforeChangeContentNotEqualTo(values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                    " not in", Arrays.asList(values), "beforeChangeContent");

                return this;
            }
        }

        public Criteria andBeforeChangeContentIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andBeforeChangeContentNotIn(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andBeforeChangeContentBetween(String value1,
            String value2) {
            addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                " between", value1, value2, "beforeChangeContent");

            return this;
        }

        public Criteria andBeforeChangeContentNotBetween(String value1,
            String value2) {
            addCriterion(IProductRequirementChangeLogDAO.BeforeChangeContent +
                " not between", value1, value2, "beforeChangeContent");

            return this;
        }

        public Criteria andAfterChangeContentIsNull() {
            addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                " is null");

            return this;
        }

        public Criteria andAfterChangeContentIsNotNull() {
            addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                " is not null");

            return this;
        }

        public Criteria andAfterChangeContentIsNotEmpty() {
            addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                " is not null AND " +
                IProductRequirementChangeLogDAO.AfterChangeContent + " <> ''");

            return this;
        }

        public Criteria andAfterChangeContentIsEmpty() {
            addCriterion("(" +
                IProductRequirementChangeLogDAO.AfterChangeContent +
                " is null OR " +
                IProductRequirementChangeLogDAO.AfterChangeContent + " = '')");

            return this;
        }

        public Criteria andAfterChangeContentEqualTo(String value) {
            addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                " = ", value, "afterChangeContent");

            return this;
        }

        public Criteria andAfterChangeContentEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.AfterChangeContent);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andAfterChangeContentEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andAfterChangeContentNotEqualTo(String value) {
            addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                " <>", value, "afterChangeContent");

            return this;
        }

        public Criteria andAfterChangeContentNotEqualToOrIsNull(String value) {
            addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                " is null OR " +
                IProductRequirementChangeLogDAO.AfterChangeContent + " <>",
                value, "afterChangeContent");

            return this;
        }

        public Criteria andAfterChangeContentNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.AfterChangeContent);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andAfterChangeContentNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andAfterChangeContentGreaterThan(String value) {
            addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                " >", value, "afterChangeContent");

            return this;
        }

        public Criteria andAfterChangeContentGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.AfterChangeContent);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andAfterChangeContentGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andAfterChangeContentGreaterThanOrEqualTo(String value) {
            addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                " >=", value, "afterChangeContent");

            return this;
        }

        public Criteria andAfterChangeContentGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.AfterChangeContent);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andAfterChangeContentGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andAfterChangeContentLessThan(String value) {
            addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                " <", value, "afterChangeContent");

            return this;
        }

        public Criteria andAfterChangeContentLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.AfterChangeContent);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andAfterChangeContentLessThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andAfterChangeContentLessThanOrEqualTo(String value) {
            addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                " <=", value, "afterChangeContent");

            return this;
        }

        public Criteria andAfterChangeContentLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.AfterChangeContent);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andAfterChangeContentLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andAfterChangeContentLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                " like", buffer.toString(), "afterChangeContent");

            return this;
        }

        public Criteria andAfterChangeContentNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                " not like", buffer.toString(), "afterChangeContent");

            return this;
        }

        public Criteria andAfterChangeContentIn(List<String> values) {
            if (values.size() == 1) {
                return andAfterChangeContentEqualTo(values.get(0));
            } else {
                addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                    " in", values, "afterChangeContent");

                return this;
            }
        }

        public Criteria andAfterChangeContentNotIn(List<String> values) {
            if (values.size() == 1) {
                return andAfterChangeContentNotEqualTo(values.get(0));
            } else {
                addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                    " not in", values, "afterChangeContent");

                return this;
            }
        }

        public Criteria andAfterChangeContentIn(String[] values) {
            if (values.length == 1) {
                return andAfterChangeContentEqualTo(values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                    " in", Arrays.asList(values), "afterChangeContent");

                return this;
            }
        }

        public Criteria andAfterChangeContentNotIn(String[] values) {
            if (values.length == 1) {
                return andAfterChangeContentNotEqualTo(values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                    " not in", Arrays.asList(values), "afterChangeContent");

                return this;
            }
        }

        public Criteria andAfterChangeContentIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andAfterChangeContentNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andAfterChangeContentBetween(String value1,
            String value2) {
            addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                " between", value1, value2, "afterChangeContent");

            return this;
        }

        public Criteria andAfterChangeContentNotBetween(String value1,
            String value2) {
            addCriterion(IProductRequirementChangeLogDAO.AfterChangeContent +
                " not between", value1, value2, "afterChangeContent");

            return this;
        }

        public Criteria andEditorIdIsNull() {
            addCriterion(IProductRequirementChangeLogDAO.EditorId + " is null");

            return this;
        }

        public Criteria andEditorIdIsNotNull() {
            addCriterion(IProductRequirementChangeLogDAO.EditorId +
                " is not null");

            return this;
        }

        public Criteria andEditorIdIsNotEmpty() {
            addCriterion(IProductRequirementChangeLogDAO.EditorId +
                " is not null AND " + IProductRequirementChangeLogDAO.EditorId +
                " <> ''");

            return this;
        }

        public Criteria andEditorIdIsEmpty() {
            addCriterion("(" + IProductRequirementChangeLogDAO.EditorId +
                " is null OR " + IProductRequirementChangeLogDAO.EditorId +
                " = '')");

            return this;
        }

        public Criteria andEditorIdEqualTo(long value) {
            return andEditorIdEqualTo(Long.valueOf(value));
        }

        public Criteria andEditorIdEqualTo(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.EditorId + " = ",
                value, "editorId");

            return this;
        }

        public Criteria andEditorIdEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.EditorId);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andEditorIdEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.EditorId + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andEditorIdNotEqualTo(long value) {
            return andEditorIdNotEqualTo(Long.valueOf(value));
        }

        public Criteria andEditorIdNotEqualTo(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.EditorId + " <>",
                value, "editorId");

            return this;
        }

        public Criteria andEditorIdNotEqualToOrIsNull(long value) {
            return andEditorIdNotEqualToOrIsNull(Long.valueOf(value));
        }

        public Criteria andEditorIdNotEqualToOrIsNull(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.EditorId +
                " is null OR " + IProductRequirementChangeLogDAO.EditorId +
                " <>", value, "editorId");

            return this;
        }

        public Criteria andEditorIdNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.EditorId);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andEditorIdNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.EditorId + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andEditorIdGreaterThan(long value) {
            return andEditorIdGreaterThan(Long.valueOf(value));
        }

        public Criteria andEditorIdGreaterThan(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.EditorId + " >",
                value, "editorId");

            return this;
        }

        public Criteria andEditorIdGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.EditorId);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andEditorIdGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.EditorId + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andEditorIdGreaterThanOrEqualTo(long value) {
            return andEditorIdGreaterThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andEditorIdGreaterThanOrEqualTo(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.EditorId + " >=",
                value, "editorId");

            return this;
        }

        public Criteria andEditorIdGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.EditorId);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andEditorIdGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.EditorId + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andEditorIdLessThan(long value) {
            return andEditorIdLessThan(Long.valueOf(value));
        }

        public Criteria andEditorIdLessThan(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.EditorId + " <",
                value, "editorId");

            return this;
        }

        public Criteria andEditorIdLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.EditorId);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andEditorIdLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.EditorId + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andEditorIdLessThanOrEqualTo(long value) {
            return andEditorIdLessThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andEditorIdLessThanOrEqualTo(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.EditorId + " <=",
                value, "editorId");

            return this;
        }

        public Criteria andEditorIdLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.EditorId);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andEditorIdLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.EditorId + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andEditorIdIn(long[] values) {
            if (values.length == 1) {
                return andEditorIdEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.EditorId + " in",
                    values, "editorId");

                return this;
            }
        }

        public Criteria andEditorIdNotIn(long[] values) {
            if (values.length == 1) {
                return andEditorIdNotEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.EditorId +
                    " not in", values, "editorId");

                return this;
            }
        }

        public Criteria andEditorIdIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andEditorIdEqualTo(values.get(0));
            } else {
                addCriterion(IProductRequirementChangeLogDAO.EditorId + " in",
                    values, "editorId");

                return this;
            }
        }

        public Criteria andEditorIdNotIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andEditorIdNotEqualTo(values.get(0));
            } else {
                addCriterion(IProductRequirementChangeLogDAO.EditorId +
                    " not in", values, "editorId");

                return this;
            }
        }

        public Criteria andEditorIdIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andEditorIdEqualTo(values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.EditorId + " in",
                    Arrays.asList(values), "editorId");

                return this;
            }
        }

        public Criteria andEditorIdNotIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andEditorIdNotEqualTo(values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.EditorId +
                    " not in", Arrays.asList(values), "editorId");

                return this;
            }
        }

        public Criteria andEditorIdIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.EditorId + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andEditorIdNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.EditorId + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andEditorIdBetween(long value1, long value2) {
            addCriterion(IProductRequirementChangeLogDAO.EditorId + " between",
                value1, value2, "editorId");

            return this;
        }

        public Criteria andEditorIdBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(IProductRequirementChangeLogDAO.EditorId + " between",
                value1, value2, "editorId");

            return this;
        }

        public Criteria andEditorIdNotBetween(long value1, long value2) {
            addCriterion(IProductRequirementChangeLogDAO.EditorId +
                " not between", value1, value2, "editorId");

            return this;
        }

        public Criteria andEditorIdNotBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(IProductRequirementChangeLogDAO.EditorId +
                " not between", value1, value2, "editorId");

            return this;
        }

        public Criteria andEditDateIsNull() {
            addCriterion(IProductRequirementChangeLogDAO.EditDate + " is null");

            return this;
        }

        public Criteria andEditDateIsNotNull() {
            addCriterion(IProductRequirementChangeLogDAO.EditDate +
                " is not null");

            return this;
        }

        public Criteria andEditDateIsNotEmpty() {
            addCriterion(IProductRequirementChangeLogDAO.EditDate +
                " is not null AND " + IProductRequirementChangeLogDAO.EditDate +
                " <> ''");

            return this;
        }

        public Criteria andEditDateIsEmpty() {
            addCriterion("(" + IProductRequirementChangeLogDAO.EditDate +
                " is null OR " + IProductRequirementChangeLogDAO.EditDate +
                " = '')");

            return this;
        }

        public Criteria andEditDateEqualTo(java.util.Date value) {
            addCriterionForJDBCDate(IProductRequirementChangeLogDAO.EditDate +
                " = ", value, "editDate");

            return this;
        }

        public Criteria andEditDateEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.EditDate);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andEditDateEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.EditDate + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andEditDateNotEqualTo(java.util.Date value) {
            addCriterionForJDBCDate(IProductRequirementChangeLogDAO.EditDate +
                " <>", value, "editDate");

            return this;
        }

        public Criteria andEditDateNotEqualToOrIsNull(java.util.Date value) {
            addCriterionForJDBCDate(IProductRequirementChangeLogDAO.EditDate +
                " is null OR " + IProductRequirementChangeLogDAO.EditDate +
                " <>", value, "editDate");

            return this;
        }

        public Criteria andEditDateNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.EditDate);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andEditDateNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.EditDate + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andEditDateGreaterThan(java.util.Date value) {
            addCriterionForJDBCDate(IProductRequirementChangeLogDAO.EditDate +
                " >", value, "editDate");

            return this;
        }

        public Criteria andEditDateGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.EditDate);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andEditDateGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.EditDate + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andEditDateGreaterThanOrEqualTo(java.util.Date value) {
            addCriterionForJDBCDate(IProductRequirementChangeLogDAO.EditDate +
                " >=", value, "editDate");

            return this;
        }

        public Criteria andEditDateGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.EditDate);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andEditDateGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.EditDate + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andEditDateLessThan(java.util.Date value) {
            addCriterionForJDBCDate(IProductRequirementChangeLogDAO.EditDate +
                " <", value, "editDate");

            return this;
        }

        public Criteria andEditDateLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.EditDate);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andEditDateLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.EditDate + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andEditDateLessThanOrEqualTo(java.util.Date value) {
            addCriterionForJDBCDate(IProductRequirementChangeLogDAO.EditDate +
                " <=", value, "editDate");

            return this;
        }

        public Criteria andEditDateLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.EditDate);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andEditDateLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.EditDate + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andEditDateIn(List<java.util.Date> values) {
            if (values.size() == 1) {
                return andEditDateEqualTo(values.get(0));
            } else {
                addCriterionForJDBCDate(IProductRequirementChangeLogDAO.EditDate +
                    " in", values, "editDate");

                return this;
            }
        }

        public Criteria andEditDateNotIn(List<java.util.Date> values) {
            if (values.size() == 1) {
                return andEditDateNotEqualTo(values.get(0));
            } else {
                addCriterionForJDBCDate(IProductRequirementChangeLogDAO.EditDate +
                    " not in", values, "editDate");

                return this;
            }
        }

        public Criteria andEditDateIn(java.util.Date[] values) {
            if (values.length == 1) {
                return andEditDateEqualTo(values[0]);
            } else {
                addCriterionForJDBCDate(IProductRequirementChangeLogDAO.EditDate +
                    " in", Arrays.asList(values), "editDate");

                return this;
            }
        }

        public Criteria andEditDateNotIn(java.util.Date[] values) {
            if (values.length == 1) {
                return andEditDateNotEqualTo(values[0]);
            } else {
                addCriterionForJDBCDate(IProductRequirementChangeLogDAO.EditDate +
                    " not in", Arrays.asList(values), "editDate");

                return this;
            }
        }

        public Criteria andEditDateIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.EditDate + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andEditDateNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.EditDate + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andEditDateBetween(java.util.Date value1,
            java.util.Date value2) {
            addCriterionForJDBCDate(IProductRequirementChangeLogDAO.EditDate +
                " between", value1, value2, "editDate");

            return this;
        }

        public Criteria andEditDateNotBetween(java.util.Date value1,
            java.util.Date value2) {
            addCriterionForJDBCDate(IProductRequirementChangeLogDAO.EditDate +
                " not between", value1, value2, "editDate");

            return this;
        }

        public Criteria andChangeReasonIsNull() {
            addCriterion(IProductRequirementChangeLogDAO.ChangeReason +
                " is null");

            return this;
        }

        public Criteria andChangeReasonIsNotNull() {
            addCriterion(IProductRequirementChangeLogDAO.ChangeReason +
                " is not null");

            return this;
        }

        public Criteria andChangeReasonIsNotEmpty() {
            addCriterion(IProductRequirementChangeLogDAO.ChangeReason +
                " is not null AND " +
                IProductRequirementChangeLogDAO.ChangeReason + " <> ''");

            return this;
        }

        public Criteria andChangeReasonIsEmpty() {
            addCriterion("(" + IProductRequirementChangeLogDAO.ChangeReason +
                " is null OR " + IProductRequirementChangeLogDAO.ChangeReason +
                " = '')");

            return this;
        }

        public Criteria andChangeReasonEqualTo(String value) {
            addCriterion(IProductRequirementChangeLogDAO.ChangeReason + " = ",
                value, "changeReason");

            return this;
        }

        public Criteria andChangeReasonEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.ChangeReason);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andChangeReasonEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.ChangeReason + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andChangeReasonNotEqualTo(String value) {
            addCriterion(IProductRequirementChangeLogDAO.ChangeReason + " <>",
                value, "changeReason");

            return this;
        }

        public Criteria andChangeReasonNotEqualToOrIsNull(String value) {
            addCriterion(IProductRequirementChangeLogDAO.ChangeReason +
                " is null OR " + IProductRequirementChangeLogDAO.ChangeReason +
                " <>", value, "changeReason");

            return this;
        }

        public Criteria andChangeReasonNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.ChangeReason);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andChangeReasonNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.ChangeReason + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andChangeReasonGreaterThan(String value) {
            addCriterion(IProductRequirementChangeLogDAO.ChangeReason + " >",
                value, "changeReason");

            return this;
        }

        public Criteria andChangeReasonGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.ChangeReason);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andChangeReasonGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.ChangeReason + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andChangeReasonGreaterThanOrEqualTo(String value) {
            addCriterion(IProductRequirementChangeLogDAO.ChangeReason + " >=",
                value, "changeReason");

            return this;
        }

        public Criteria andChangeReasonGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.ChangeReason);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andChangeReasonGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.ChangeReason + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andChangeReasonLessThan(String value) {
            addCriterion(IProductRequirementChangeLogDAO.ChangeReason + " <",
                value, "changeReason");

            return this;
        }

        public Criteria andChangeReasonLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.ChangeReason);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andChangeReasonLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.ChangeReason + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andChangeReasonLessThanOrEqualTo(String value) {
            addCriterion(IProductRequirementChangeLogDAO.ChangeReason + " <=",
                value, "changeReason");

            return this;
        }

        public Criteria andChangeReasonLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.ChangeReason);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andChangeReasonLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.ChangeReason + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andChangeReasonLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(IProductRequirementChangeLogDAO.ChangeReason +
                " like", buffer.toString(), "changeReason");

            return this;
        }

        public Criteria andChangeReasonNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(IProductRequirementChangeLogDAO.ChangeReason +
                " not like", buffer.toString(), "changeReason");

            return this;
        }

        public Criteria andChangeReasonIn(List<String> values) {
            if (values.size() == 1) {
                return andChangeReasonEqualTo(values.get(0));
            } else {
                addCriterion(IProductRequirementChangeLogDAO.ChangeReason +
                    " in", values, "changeReason");

                return this;
            }
        }

        public Criteria andChangeReasonNotIn(List<String> values) {
            if (values.size() == 1) {
                return andChangeReasonNotEqualTo(values.get(0));
            } else {
                addCriterion(IProductRequirementChangeLogDAO.ChangeReason +
                    " not in", values, "changeReason");

                return this;
            }
        }

        public Criteria andChangeReasonIn(String[] values) {
            if (values.length == 1) {
                return andChangeReasonEqualTo(values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.ChangeReason +
                    " in", Arrays.asList(values), "changeReason");

                return this;
            }
        }

        public Criteria andChangeReasonNotIn(String[] values) {
            if (values.length == 1) {
                return andChangeReasonNotEqualTo(values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.ChangeReason +
                    " not in", Arrays.asList(values), "changeReason");

                return this;
            }
        }

        public Criteria andChangeReasonIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.ChangeReason + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andChangeReasonNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.ChangeReason +
                " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andChangeReasonBetween(String value1, String value2) {
            addCriterion(IProductRequirementChangeLogDAO.ChangeReason +
                " between", value1, value2, "changeReason");

            return this;
        }

        public Criteria andChangeReasonNotBetween(String value1, String value2) {
            addCriterion(IProductRequirementChangeLogDAO.ChangeReason +
                " not between", value1, value2, "changeReason");

            return this;
        }

        public Criteria andApproverIdIsNull() {
            addCriterion(IProductRequirementChangeLogDAO.ApproverId +
                " is null");

            return this;
        }

        public Criteria andApproverIdIsNotNull() {
            addCriterion(IProductRequirementChangeLogDAO.ApproverId +
                " is not null");

            return this;
        }

        public Criteria andApproverIdIsNotEmpty() {
            addCriterion(IProductRequirementChangeLogDAO.ApproverId +
                " is not null AND " +
                IProductRequirementChangeLogDAO.ApproverId + " <> ''");

            return this;
        }

        public Criteria andApproverIdIsEmpty() {
            addCriterion("(" + IProductRequirementChangeLogDAO.ApproverId +
                " is null OR " + IProductRequirementChangeLogDAO.ApproverId +
                " = '')");

            return this;
        }

        public Criteria andApproverIdEqualTo(long value) {
            return andApproverIdEqualTo(Long.valueOf(value));
        }

        public Criteria andApproverIdEqualTo(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.ApproverId + " = ",
                value, "approverId");

            return this;
        }

        public Criteria andApproverIdEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.ApproverId);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andApproverIdEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.ApproverId + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andApproverIdNotEqualTo(long value) {
            return andApproverIdNotEqualTo(Long.valueOf(value));
        }

        public Criteria andApproverIdNotEqualTo(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.ApproverId + " <>",
                value, "approverId");

            return this;
        }

        public Criteria andApproverIdNotEqualToOrIsNull(long value) {
            return andApproverIdNotEqualToOrIsNull(Long.valueOf(value));
        }

        public Criteria andApproverIdNotEqualToOrIsNull(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.ApproverId +
                " is null OR " + IProductRequirementChangeLogDAO.ApproverId +
                " <>", value, "approverId");

            return this;
        }

        public Criteria andApproverIdNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.ApproverId);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andApproverIdNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.ApproverId + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andApproverIdGreaterThan(long value) {
            return andApproverIdGreaterThan(Long.valueOf(value));
        }

        public Criteria andApproverIdGreaterThan(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.ApproverId + " >",
                value, "approverId");

            return this;
        }

        public Criteria andApproverIdGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.ApproverId);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andApproverIdGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.ApproverId + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andApproverIdGreaterThanOrEqualTo(long value) {
            return andApproverIdGreaterThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andApproverIdGreaterThanOrEqualTo(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.ApproverId + " >=",
                value, "approverId");

            return this;
        }

        public Criteria andApproverIdGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.ApproverId);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andApproverIdGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.ApproverId + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andApproverIdLessThan(long value) {
            return andApproverIdLessThan(Long.valueOf(value));
        }

        public Criteria andApproverIdLessThan(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.ApproverId + " <",
                value, "approverId");

            return this;
        }

        public Criteria andApproverIdLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.ApproverId);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andApproverIdLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.ApproverId + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andApproverIdLessThanOrEqualTo(long value) {
            return andApproverIdLessThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andApproverIdLessThanOrEqualTo(java.lang.Long value) {
            addCriterion(IProductRequirementChangeLogDAO.ApproverId + " <=",
                value, "approverId");

            return this;
        }

        public Criteria andApproverIdLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.ApproverId);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andApproverIdLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.ApproverId + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andApproverIdIn(long[] values) {
            if (values.length == 1) {
                return andApproverIdEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.ApproverId +
                    " in", values, "approverId");

                return this;
            }
        }

        public Criteria andApproverIdNotIn(long[] values) {
            if (values.length == 1) {
                return andApproverIdNotEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.ApproverId +
                    " not in", values, "approverId");

                return this;
            }
        }

        public Criteria andApproverIdIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andApproverIdEqualTo(values.get(0));
            } else {
                addCriterion(IProductRequirementChangeLogDAO.ApproverId +
                    " in", values, "approverId");

                return this;
            }
        }

        public Criteria andApproverIdNotIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andApproverIdNotEqualTo(values.get(0));
            } else {
                addCriterion(IProductRequirementChangeLogDAO.ApproverId +
                    " not in", values, "approverId");

                return this;
            }
        }

        public Criteria andApproverIdIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andApproverIdEqualTo(values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.ApproverId +
                    " in", Arrays.asList(values), "approverId");

                return this;
            }
        }

        public Criteria andApproverIdNotIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andApproverIdNotEqualTo(values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.ApproverId +
                    " not in", Arrays.asList(values), "approverId");

                return this;
            }
        }

        public Criteria andApproverIdIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.ApproverId + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andApproverIdNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.ApproverId +
                " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andApproverIdBetween(long value1, long value2) {
            addCriterion(IProductRequirementChangeLogDAO.ApproverId +
                " between", value1, value2, "approverId");

            return this;
        }

        public Criteria andApproverIdBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(IProductRequirementChangeLogDAO.ApproverId +
                " between", value1, value2, "approverId");

            return this;
        }

        public Criteria andApproverIdNotBetween(long value1, long value2) {
            addCriterion(IProductRequirementChangeLogDAO.ApproverId +
                " not between", value1, value2, "approverId");

            return this;
        }

        public Criteria andApproverIdNotBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(IProductRequirementChangeLogDAO.ApproverId +
                " not between", value1, value2, "approverId");

            return this;
        }

        public Criteria andStatusIsNull() {
            addCriterion(IProductRequirementChangeLogDAO.Status + " is null");

            return this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion(IProductRequirementChangeLogDAO.Status +
                " is not null");

            return this;
        }

        public Criteria andStatusIsNotEmpty() {
            addCriterion(IProductRequirementChangeLogDAO.Status +
                " is not null AND " + IProductRequirementChangeLogDAO.Status +
                " <> ''");

            return this;
        }

        public Criteria andStatusIsEmpty() {
            addCriterion("(" + IProductRequirementChangeLogDAO.Status +
                " is null OR " + IProductRequirementChangeLogDAO.Status +
                " = '')");

            return this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion(IProductRequirementChangeLogDAO.Status + " = ", value,
                "status");

            return this;
        }

        public Criteria andStatusEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.Status);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.Status + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion(IProductRequirementChangeLogDAO.Status + " <>", value,
                "status");

            return this;
        }

        public Criteria andStatusNotEqualToOrIsNull(String value) {
            addCriterion(IProductRequirementChangeLogDAO.Status +
                " is null OR " + IProductRequirementChangeLogDAO.Status +
                " <>", value, "status");

            return this;
        }

        public Criteria andStatusNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.Status);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.Status + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion(IProductRequirementChangeLogDAO.Status + " >", value,
                "status");

            return this;
        }

        public Criteria andStatusGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.Status);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.Status + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion(IProductRequirementChangeLogDAO.Status + " >=", value,
                "status");

            return this;
        }

        public Criteria andStatusGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.Status);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.Status + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion(IProductRequirementChangeLogDAO.Status + " <", value,
                "status");

            return this;
        }

        public Criteria andStatusLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.Status);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.Status + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion(IProductRequirementChangeLogDAO.Status + " <=", value,
                "status");

            return this;
        }

        public Criteria andStatusLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.Status);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusLessThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.Status + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andStatusLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(IProductRequirementChangeLogDAO.Status + " like",
                buffer.toString(), "status");

            return this;
        }

        public Criteria andStatusNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(IProductRequirementChangeLogDAO.Status + " not like",
                buffer.toString(), "status");

            return this;
        }

        public Criteria andStatusIn(List<String> values) {
            if (values.size() == 1) {
                return andStatusEqualTo(values.get(0));
            } else {
                addCriterion(IProductRequirementChangeLogDAO.Status + " in",
                    values, "status");

                return this;
            }
        }

        public Criteria andStatusNotIn(List<String> values) {
            if (values.size() == 1) {
                return andStatusNotEqualTo(values.get(0));
            } else {
                addCriterion(IProductRequirementChangeLogDAO.Status +
                    " not in", values, "status");

                return this;
            }
        }

        public Criteria andStatusIn(String[] values) {
            if (values.length == 1) {
                return andStatusEqualTo(values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.Status + " in",
                    Arrays.asList(values), "status");

                return this;
            }
        }

        public Criteria andStatusNotIn(String[] values) {
            if (values.length == 1) {
                return andStatusNotEqualTo(values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.Status +
                    " not in", Arrays.asList(values), "status");

                return this;
            }
        }

        public Criteria andStatusIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.Status + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andStatusNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.Status + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion(IProductRequirementChangeLogDAO.Status + " between",
                value1, value2, "status");

            return this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion(IProductRequirementChangeLogDAO.Status +
                " not between", value1, value2, "status");

            return this;
        }

        public Criteria andRemarksIsNull() {
            addCriterion(IProductRequirementChangeLogDAO.Remarks + " is null");

            return this;
        }

        public Criteria andRemarksIsNotNull() {
            addCriterion(IProductRequirementChangeLogDAO.Remarks +
                " is not null");

            return this;
        }

        public Criteria andRemarksIsNotEmpty() {
            addCriterion(IProductRequirementChangeLogDAO.Remarks +
                " is not null AND " + IProductRequirementChangeLogDAO.Remarks +
                " <> ''");

            return this;
        }

        public Criteria andRemarksIsEmpty() {
            addCriterion("(" + IProductRequirementChangeLogDAO.Remarks +
                " is null OR " + IProductRequirementChangeLogDAO.Remarks +
                " = '')");

            return this;
        }

        public Criteria andRemarksEqualTo(String value) {
            addCriterion(IProductRequirementChangeLogDAO.Remarks + " = ",
                value, "remarks");

            return this;
        }

        public Criteria andRemarksEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.Remarks);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.Remarks + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksNotEqualTo(String value) {
            addCriterion(IProductRequirementChangeLogDAO.Remarks + " <>",
                value, "remarks");

            return this;
        }

        public Criteria andRemarksNotEqualToOrIsNull(String value) {
            addCriterion(IProductRequirementChangeLogDAO.Remarks +
                " is null OR " + IProductRequirementChangeLogDAO.Remarks +
                " <>", value, "remarks");

            return this;
        }

        public Criteria andRemarksNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.Remarks);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.Remarks + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksGreaterThan(String value) {
            addCriterion(IProductRequirementChangeLogDAO.Remarks + " >", value,
                "remarks");

            return this;
        }

        public Criteria andRemarksGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.Remarks);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.Remarks + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(String value) {
            addCriterion(IProductRequirementChangeLogDAO.Remarks + " >=",
                value, "remarks");

            return this;
        }

        public Criteria andRemarksGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.Remarks);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.Remarks + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksLessThan(String value) {
            addCriterion(IProductRequirementChangeLogDAO.Remarks + " <", value,
                "remarks");

            return this;
        }

        public Criteria andRemarksLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.Remarks);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.Remarks + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksLessThanOrEqualTo(String value) {
            addCriterion(IProductRequirementChangeLogDAO.Remarks + " <=",
                value, "remarks");

            return this;
        }

        public Criteria andRemarksLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(IProductRequirementChangeLogDAO.Remarks);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.Remarks + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(IProductRequirementChangeLogDAO.Remarks + " like",
                buffer.toString(), "remarks");

            return this;
        }

        public Criteria andRemarksNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(IProductRequirementChangeLogDAO.Remarks + " not like",
                buffer.toString(), "remarks");

            return this;
        }

        public Criteria andRemarksIn(List<String> values) {
            if (values.size() == 1) {
                return andRemarksEqualTo(values.get(0));
            } else {
                addCriterion(IProductRequirementChangeLogDAO.Remarks + " in",
                    values, "remarks");

                return this;
            }
        }

        public Criteria andRemarksNotIn(List<String> values) {
            if (values.size() == 1) {
                return andRemarksNotEqualTo(values.get(0));
            } else {
                addCriterion(IProductRequirementChangeLogDAO.Remarks +
                    " not in", values, "remarks");

                return this;
            }
        }

        public Criteria andRemarksIn(String[] values) {
            if (values.length == 1) {
                return andRemarksEqualTo(values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.Remarks + " in",
                    Arrays.asList(values), "remarks");

                return this;
            }
        }

        public Criteria andRemarksNotIn(String[] values) {
            if (values.length == 1) {
                return andRemarksNotEqualTo(values[0]);
            } else {
                addCriterion(IProductRequirementChangeLogDAO.Remarks +
                    " not in", Arrays.asList(values), "remarks");

                return this;
            }
        }

        public Criteria andRemarksIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.Remarks + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(IProductRequirementChangeLogDAO.Remarks + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion(IProductRequirementChangeLogDAO.Remarks + " between",
                value1, value2, "remarks");

            return this;
        }

        public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion(IProductRequirementChangeLogDAO.Remarks +
                " not between", value1, value2, "remarks");

            return this;
        }
    }
}
